Skip Headers

Oracle® SQL*Module for Ada Programmer's Guide 10g Release 2 (10.2) Part Number A58231-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# D SQLSTATE Codes

This appendix contains a table of the SQLSTATE codes and the conditions and errors associated with them.

## SQLSTATE Codes

Code | Condition | Oracle Error
--- | --- | ---
00000 | successful completion | ORA-00000
01000 | warning |
01001 | cursor operation conflict |
01002 | disconnect error |
01003 | null value eliminated in set function |
01004 | string data - right truncation |
01005 | insufficient item descriptor areas |
01006 | privilege not revoked |
01007 | privilege not granted |
01008 | implicit zero-bit padding |
01009 | search condition too long for info schema |
0100A | query expression too long for info schema |
02000 | no data | ORA-01095 ORA-01403
07000 | dynamic SQL error |
07001 | using clause does not match parameter specs |
07002 | using clause does not match target specs |
07003 | cursor specification cannot be executed |
07004 | using clause required for dynamic parameters |
07005 | prepared statement not a cursor specification |
07006 | restricted datatype attribute violation |
07007 | using clause required for result fields |
07008 | invalid descriptor count | SQL-02126
07009 | invalid descriptor index |
08000 | connection exception |
08001 | SQL client unable to establish SQL connection |
08002 | connection name in use |
08003 | connection does not exist | SQL-02121
08004 | SQL server rejected SQL connection |
08006 | connection failure |
08007 | transaction resolution unknown |
0A000 | feature not supported | ORA-03000 .. 03099
0A001 | multiple server transactions |
21000 | cardinality violation | ORA-01427 SQL-02112
22000 | data exception |
22001 | string data - right truncation | ORA-01401 ORA-01406
22002 | null value - no indicator parameter | ORA-01405 SQL-02124
22003 | numeric value out of range | ORA-01426 ORA-01438 ORA-01455 ORA-01457
22005 | error in assignment |
22007 | invalid date-time format |
22008 | date-time field overflow | ORA-01800 .. 01899
22009 | invalid time zone displacement value |
22011 | substring error |
22012 | division by zero | ORA-01476
22015 | interval field overflow |
22018 | invalid character value for cast |
22019 | invalid escape character | ORA-00911 ORA-01425
22021 | character not in repertoire |
22022 | indicator overflow | ORA-01411
22023 | invalid parameter value | ORA-01025 ORA-01488 ORA-04000 .. 04019
22024 | unterminated C string | ORA-01479 .. 01480
22025 | invalid escape sequence | ORA-01424
22026 | string data - length mismatch |
22027 | trim error |
23000 | integrity constraint violation | ORA-00001 ORA-02290 .. 02299
24000 | invalid cursor state | ORA-01001 .. 01003 ORA-01410 ORA-08006 SQL-02114 SQL-02117 SQL-02118 SQL-02122
25000 | invalid transaction state |
26000 | invalid SQL statement name |
27000 | triggered data change violation |
28000 | invalid authorization specification |
2A000 | direct SQL syntax error or access rule violation |
2B000 | dependent privilege descriptors still exist |
2C000 | invalid character set name |
2D000 | invalid transaction termination |
2E000 | invalid connection name |
33000 | invalid SQL descriptor name |
34000 | invalid cursor name |
35000 | invalid condition number |
37000 | dynamic SQL syntax error or access rule violation |
3C000 | ambiguous cursor name |
3D000 | invalid catalog name |
3F000 | invalid schema name |
40000 | transaction rollback | ORA-02091 .. 02092
40001 | serialization failure |
40002 | integrity constraint violation |
40003 | statement completion unknown |
42000 | syntax error or access rule violation | ORA-00022 ORA-00251 ORA-00900 .. 00999 ORA-01031 ORA-01490 .. 01493 ORA-01700 .. 01799 ORA-01900 .. 02099 ORA-02140 .. 02289 ORA-02420 .. 02424 ORA-02450 .. 02499 ORA-03276 .. 03299 ORA-04040 .. 04059 ORA-04070 .. 04099
44000 | with check option violation | ORA-01402
60000 | system errors | ORA-00370 .. 00429 ORA-00600 .. 00899 ORA-06430 .. 06449 ORA-07200 .. 07999 ORA-09700 .. 09999
61000 | resource error | ORA-00018 .. 00035 ORA-00050 .. 00068 ORA-02376 .. 02399 ORA-04020 .. 04039
62000 | path name server and detached process errors | ORA-00100 .. 00120 ORA-00440 .. 00569
63000 | Oracle*XA and two-task interface errors | ORA-00150 .. 00159 SQL-02128 ORA-02700 .. 02899 ORA-03100 .. 03199 ORA-06200 .. 06249
64000 | control file, database file, and redo file errors; archival and media recovery errors | ORA-00200 .. 00369 ORA-01100 .. 01250
65000 | PL/SQL errors | ORA-06500 .. 06599
66000 | SQL*Net driver errors | ORA-06000 .. 06149 ORA-06250 .. 06429 ORA-06600 .. 06999 ORA-12100 .. 12299 ORA-12500 .. 12599
67000 | licensing errors | ORA-00430 .. 00439
69000 | SQL*Connect errors | ORA-00570 .. 00599 ORA-07000 .. 07199
72000 | SQL execute phase errors | ORA-01000 .. 01099 ORA-01400 .. 01489 ORA-01495 .. 01499 ORA-01500 .. 01699 ORA-02400 .. 02419 ORA-02425 .. 02449 ORA-04060 .. 04069 ORA-08000 .. 08190 ORA-12000 .. 12019 ORA-12300 .. 12499 ORA-12700 .. 21999
82100 | out of memory (could not allocate) | SQL-02100
82101 | inconsistent cursor cache: unit cursor/global cursor mismatch | SQL-02101
82102 | inconsistent cursor cache: no global cursor entry | SQL-02102
82103 | inconsistent cursor cache: out of range cursor cache reference | SQL-02103
82104 | inconsistent host cache: no cursor cache available | SQL-02104
82105 | inconsistent cursor cache: global cursor not found | SQL-02105
82106 | inconsistent cursor cache: invalid Oracle cursor number | SQL-02106
82107 | program too old for runtime library | SQL-02107
82108 | invalid descriptor passed to runtime library | SQL-02108
82109 | inconsistent host cache: host reference is out of range | SQL-02109
82110 | inconsistent host cache: invalid host cache entry type | SQL-02110
82111 | heap consistency error | SQL-02111
82112 | unable to open message file | SQL-02113
82113 | code generation internal consistency failed | SQL-02115
82114 | reentrant code generator gave invalid context | SQL-02116
82115 | invalid hstdef argument | SQL-02119
82116 | first and second arguments to sqlrcn both null | SQL-02120
82117 | invalid OPEN or PREPARE for this connection | SQL-02122
82118 | application context not found | SQL-02123
82119 | connect error; can't get error text | SQL-02125
82120 | precompiler/SQLLIB version mismatch. | SQL-02127
82121 | FETCHed number of bytes is odd | SQL-02129
82122 | EXEC TOOLS interface is not available | SQL-02130
90000 | debug events | ORA-10000 .. 10999
99999 | catch all | all others
HZ000 | remote database access |